<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ page import="java.util.*,zzz.jdbc.*,zzz.vo.*,zzz.util.*,java.text.*"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>查询结果</title>
</head>
<body>

	<%
		List<Student> stulist = new JDBCTools().searchStudents(request.getParameter("searchkey"));
	  
		request.setAttribute("stulist", stulist);
	%>

	<table border="1">
		<tr>
			<th>学号</th>
			<th>姓名</th>
			<th>专业</th>
			<th>性别</th>
			<th>出生日期</th>
			<th>总学分</th>
			<th>备注</th>
		</tr>
		<c:forEach var="stu" items="${stulist}" varStatus="status">
			<tr>
				<td>${stu.getStuNo()}</td>
				<td>${stu.getName()}</td>
				<td>${stu.getMajor()}</td>
				<td>${stu.getSex()}</td>
				
				<td>${stu.getDateOfBirthToString()}</td>
				<td>${stu.getAllCredits()}</td>
				<td>${stu.getRemark()}</td>
				
			</tr>
		</c:forEach>

	</table>
<p>
<a href="mainManage.jsp">返回主界面</a>
</p>
</body>
</html>